﻿CREATE TABLE [dbo].[tblPerfmon]
(
	date_inserted datetime NOT NULL,
	buffer_cache_hit_ratio numeric(5, 2) NULL,
	page_life_expectancy bigint NULL,
	logins_per_sec bigint NULL,
	logouts_per_sec bigint NULL,
	user_connections bigint NULL,
	optimizer_memory_KB bigint NULL,
	sql_cache_memory_KB bigint NULL,
	target_server_memory_KB bigint NULL,
	total_server_memory_KB bigint NULL,
	sql_compilations_per_sec bigint NULL,
	sql_recompilations_per_sec bigint NULL,
	batch_requests_per_sec bigint NULL,
	number_of_deadlocks_per_sec bigint NULL,
	average_wait_time_ms bigint NULL,
	lock_waits_per_sec bigint NULL,
	lock_wait_time_ms bigint NULL,
	full_scans_per_sec bigint NULL,
	lazy_writes_per_sec bigint NULL,
	page_reads_per_sec bigint NULL,
	page_writes_per_sec bigint NULL,
	checkpoint_pages_per_sec bigint NULL,
	page_splits_per_sec bigint NULL,
	transactions_per_sec bigint NULL,
	cpu_busy bigint NULL,
	io_busy bigint NULL,
	idle bigint NULL,
	CONSTRAINT PK_perfmon PRIMARY KEY CLUSTERED (date_inserted ASC)
)
